
if exists(select name from sysobjects where name = 'sp_TinGetById')
	drop proc sp_TinGetById
go
/*
	Created by: Phuoc NH
	Created on: 22/01/2013 (dd/mm/yyyy)
	Description: lay danh muc san pham hien danh muc, hien trang chu....
	--
	File:$sql-scripts/Proc.sp_TinGetById.sql
*/
create proc sp_TinGetById
@Tin_id int
as
begin
	select Tin_id, Tieu_de, Tom_tat, Noi_dung, Anh_to, Url, Anh_nho, Anh_to, vi_tri from tbl_Tin where Tin_id=@Tin_id and Status=1
end
go